5. Consider the following products data which contain duplicate rows.
A
B
C
C
B
D
B
Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table.
The first table should contain the following output
A
D
The second target should contain the following output
B
B
B
C
C
No Answer is Posted For this Question
Be the First to Post Answer
how DTM buffer size and buffer block size are related
WAT IS TEXT LOAD?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Diffrence between 7.1,8.1 and 8.6
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How mapping parameter and variable works
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
What is the Process to creating lookup transformation in informatica
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
To achieve the session partition what r the necessary tasks u have to do?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL