Interested to Buy Any Domain ? << Click Here >> for more details...
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
- 1 Answers
- 3403 Views
- Franklin Templeton, I also Faced
- E-Mail Answers
Answer / dilip ingole
use sql override in SQ
ans use query as fellow
SELECT NUM,CASE WHEN ROWNUM <=(SELECT COUNT(1)/2 FROM TABLE_NAME) THEN 1 ELSE 0 END FLAG FROM TABLE_NAME;
in informatica filter record based on flag if flag is 1 then send it to one target else to second target
| Is This Answer Correct ? | 0 Yes | 0 No |
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
How many cubes create from a single model?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
How can we create index after completion of load process?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
Define Pmrep command?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
How to jion 2 tables, without using any condition?
What are the informatica performance improvement tips
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Teradata 
