Interested to Buy Any Domain ? << Click Here >> for more details...
how to get flatfile containg 10 records half records one
target another half another target
- 2 Answers
- 5649 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahipal reddy
first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / gazulas
what if the number 10 changes??
use a sql transfermation and get the record count or use an agg get rec count and pass it into record_count. use seq gen and populate the numbers. then use a router and write condition seq no <= record_count/2 -- target1
default to target 2.
this will work even ur records changes to 100 or 25o or 40000..etc
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a passive transformation?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
I want load the data into target with out 1st and last record.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
What is joiner cache?
How to improve the performance of a session using sorter transformation?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
What is the use of incremental aggregation?
What is the format of informatica objects in a repository?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
Teradata 
