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


Please Help Members By Posting Answers For Below Questions

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6580


Enlist few areas or real-time situations where informatica is required.

657


How to create Target definition for flat files?

837


r u done any partitions in ur project?

1454


How to generate or load values in to the target table based on a column value using informatica etl tool.

678






Explain in detail about scd type 1 through mapping.

660


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

729


How can you increase the performance in joiner transformation?

778


How many ways are there to do 'remove duplicate records in informatica'?

645


How do you update the records with or without using update strategy?

730


What are ETL Tools?

727


In development project what is the process to follow for an etl developer from day1

1347


How can we store previous session logs?

633


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1714


How we can create indexes after completing the loan process?

813