Source
---------
eno , ename, sal
001,ank,1000
002,behe,2000
003,raj,2500
Target
-------
header :DDMMYYYY24MMSS timestamp
body: 001,ank,1000
002,behe,2000
003,raj,2500
footer: count(eno),sum(sal)
how to implement the same in a FF tgt?
Answer Posted / pooja
Watch Out this link:
https://www.youtube.com/watch?v=zKNVn9Rhn5o
It is similar to the question posted
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Clarify the utilization of aggregator cache record?
Write the different tools in the workflow manager?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explian the Process of deployment groups in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
what is the size of u r source(like file or table)?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
EXL informatica Questions
What is an aggregator transformation?
What is the scenario which compels informatica server to reject files?
Explain sessions. Explain how batches are used to combine executions?
Differentiate between sessions and batches?
Explain the different lookup methods used in informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N