i have source file data empno,ename,sal 100,ram,1000
200,tyu,2000 300,gh,3000 out put as e
empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
Answer Posted / rsbandaru
Ok..Integration service by default assigns value 'o' to the
variable port..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are ETL Tools?
Is stop and abort are same in informatica?
How to load a Dimension ? and how to load a fact table?
What is persistent lookup cache?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Did u used latest transformations of 8.6.0? for what?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Please let me know how to make Data masking in informatica..
How are the sources and targets definitions imported in informatica designer?
What is the difference between router and filter?
What is meant by lookup transformation?
What is domain in terms of informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain what is informatica metadata and where is it stored?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures