Interested to Buy Any Domain ? << Click Here >> for more details...
Source and Target are flat files, Source table is as below
ID,NAME
1,X
1,X
2,Y
2,Y
On Target flat file i want the data to be loaded as
mentioned below
ID,NAME,REPEAT
1,X,2
1,X,2
2,Y,2
2,Y,2
How to achieve this, Can i get a map structure
- 2 Answers
- 7494 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / santa
SRC->SQ->SRT->AGG
JNR TAR
SRC->SQ->SRT->EXP->
AGG INPUT/OUPUT-> ID
AGG VARIABLE/OUTPUT->COUNT(ID)
JNR COND:- ID1=ID
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
Enlist the tasks for which source qualifier transformation is used.
what is song in infrmatica...?
What is powercenter on grid?
Differentiate between source qualifier and filter transformation?
What is a code page?
What is target designer and target load order?
How identifying bottlenecks in various components of informatica and resolving them?
How to load the data from people soft hrm to people soft erm using informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the function of union transformation?
What do you mean by enterprise data warehousing?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is lookup change?
