1.look at the following tree structure diagram. From the tree structure, you can easily derive the
parent-child relationship between the elements. For example, B is parent of D and E.
The above tree structure data is represented in a table as shown below.
c1, c2, c3, c4
A, B, D, H
A, B, D, I
A, B, E, NULL
A, C, F, NULL
A, C, G, NULL
Here in this table, column C1 is parent of column C2, column C2 is parent of column C3, column C3
is parent of column C4.
. Design a mapping to load the target table with the below data. Here you need to generate sequence numbers for each element and then you have to get the parent id. As the element “A” is at root, it does not have any parent and its parent_id is NULL.
id, element, parent_id
1, A, NULL
2, B, 1
3, C, 1
4, D, 2
5, E, 2
6, F, 3
7, G, 3
8, H, 4
9, I, 4
. This is an extension to the problem Q1. Let say column C2 has null for all the rows, then C1 becomes the parent of C3 and c3 is parent of C4. Let say both columns c2 and c3 has null for all the rows. Then c1 becomes the parent of c4. Design a mapping to accommodate these type of null
2.How to Concat row data through informatica?
Using Dynamic Lookup on Target table:
If record doesn’t exit do insert in target .If it is already exist then get corresponding Ename vale from lookup and concat in expression with current Ename value then update the target Ename column using update strategy.
Using Var port Approach:
Sort the data in sq based on EmpNo column then Use expression to store previous record information using Var port after that use router to insert a record if it is first time if it is already inserted then update Ename with concat value of prev name and current name value then update in target.
3:How to load single source data in four different target based upon session run through single mapping.
Ex: One Source (Emp Table)
1st run of Session–>EMP_TGT1
2nd run of Session–>EMP_TGT2
3rd run of Session–>EMP_TGT3
4th run of Session–>EMP_TGT4
5th run of Session–>EMP_TGT1
4. Split Total Number of Records in two parts and load it based upon session run.
Ex: Emp table has 14 records. On first time session run 7 records should be loaded and on second time run remaining 7 records should be loaded.
In other words we can say on each run only 7 records should be loaded.
5.How to load multi-format (Delimited) column Flat File source data into two different targets?
6. How to Convert Column To Row
7. How to Achieve Target below…
8. How to Achieve Target below…
9.How to Achieve Target below…
Note: NULL are just for representation. There is no value in that column.
ID NAME LOC
101 SIMITH USA
102 JOHN UK
10. How to achieve target below…
BRAND_ID, PRODUCT, TOTAL_PRICE
11. How to achieve target below…
Column1 Column2 Column3
JAVA ORACLE INFORMATICA
60 50 78
JAVA ORACLE INFORMATICA
45 55 52
12: How to Convert Row to Column and convert four column data to eight column data.
7369, SMITH, CLERK, 7902
17-DEC-1980, 800, 400, 20
7499, ALLEN, SALESMAN, 7698
20-FEB-1981, 1600, 300, 30
7521, WARD, SALESMAN, 7698
22-FEB-1981, 1250, 500, 30
7566, JONES, MANAGER, 7839
2-APR-1981, 2975, 400, 20
7654, MARTIN, SALESMAN, 7698
28-SEP-1981, 1250, 1400, 30
13: How to assign an id for specified group of records and achieve target below.
14: How to insert same group of data in single column.