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
- 5538 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 |
How to load last n records of file into target table - informatica
what is the difference between stop and abort
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
In how many ways we can create ports?
i have 2 session s1 execute s2 load first session fail what is the reason?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
what is dynamic cashe
whether Sequence generater T/r uses Caches? then what type of Cache it is
Explain the different kinds of facts.
How to generate sequence numbers without using the sequence generator transformation?
Where do we use mapping variables in informatica?
Teradata 
