Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source table and 3 target table.
when session runs first time-1st tgt
second time-2nd tgt
third time-3rd tgt
fourth time-again 1st target. so no
- 4 Answers
- 7244 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sg
SQ-Exp-Rou-Tg1 TG2 Tg3
Exp transformation: for generating sequence number ( u can use sequence generator setting max value to 3)
o_count = iff(o_count=0 or o_count=4,1,o_count+1)
Router group condition,
O_cout=1, TG1
O_cout=2, TG2
O_cout=3, TG3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a database and data warehouse?
Explain incremental aggregation in informatica
What is a code page?
Design time, run time. If you don't create parameter what will happen
What is a router transformation?
Global and Local shortcuts. Advantages.
What are the different lookup cache(s)?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the types of caches in lookup?
What are roles and groups and benefits of using them?
COM components can be used in Informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
where to store informatica rejected data?
What is informatica powercenter repository?
Explain the aggregator transformation?
