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
- 7388 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
Slowly changing dimensions, types and where will you use them
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to implement security measures using repository manager?
What are the different types of transformation available in informatica.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the different versions of informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Which development components of informatica have the highest usage?
Different qualification between a related rotate toward the sky and isolates look upward?
How many ways are there to create ports?
What is the difference between informatics 7x and 8x and what is latest version?
Define enterprise data warehousing?
What are the databases that informatica can connect to windows?
permutations of mapplet
Performance tuning in UNIX for informatica mappings?
