Interested to Buy Any Domain ? << Click Here >> for more details...
i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow
- 4 Answers
- 12198 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vani
Can it be done in this way....
1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.
If i am wrong please tell me....
| Is This Answer Correct ? | 27 Yes | 4 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
Can we change Dynamic to Static or Persistent cache? If so what happens?
tell me the rules and responsblites in our project(my project is development)
Performance tuning in UNIX for informatica mappings?
what is $$$$?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How can you differentiate between powercenter and power map?
Separate from an archive server and a powerhouse?
What is depict expression change?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain the code page compatibility?
If informatica has its scheduler why using third party scheduler?
Why update strategy and union transformations are active? Explain with examples.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
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
