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
- 5655 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 |
In which circumstances that informatica server creates Reject files?
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
in performance wise union is past,union all is past
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Types of error logs in Informatica?
what is bitmap index? did u use it?and how to use it in informatica
What is informatica worklet?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
How do you implement unconn. Stored proc. In a mapping?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
what is pre and post sql and what is diff between source presql and target pre sql
Teradata 
