i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details
- 8 Answers
- 15913 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / babu
Frnds small change in the above answer..
i.e: GRP1 :O_SEQ1>=O_SEQ2 ,GRP2: O_SEQ1<O_SEQ2
OR
GRP1 :O_SEQ1>O_SEQ2 ,GRP2: O_SEQ1<=O_SEQ2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
complex mapping ur project u r invlve can u explain and give real time example give me ?
whats the logic to load the lower level of granularity of data to fact table.
Explain pmcmd command usage in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Where can we find the throughput option in informatica?
Which transformation should we use to normalise the COBOL and relational sources?
What are session parameters ? How do you set them?
Under what condition selecting sorted input in aggregator may fail the session?
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
What is the procedure for creating independent data marts from informatica 7.1?
Briefly describe lookup transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the cumulative sum and moving sum?
Differentiate between joiner and lookup transformation?
