Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18159 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mike
target1
src-->sq-->seq gen-->rtr--> /
\
target 2
drag the source. create an sequence generator
transformation and then pass all the data to router create
two groups in the router transformation pass it to
target...You can give the condition in the router
transformation based on your requirement. if it is like odd
and even...you can use mod function in the router
transformation.
Mod function returns 0 passit to t2 and mod function
returns 1 pass it to t1
hope this works...correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to generate sequence numbers?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is domain in terms of informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the types of caches in lookup?
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.
What is the Process to creating lookup transformation in informatica
How do we call shell scripts from informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Differentiate between reusable transformation and mapplet.
What is Cognos script editor?
