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 / ravi

logic IS GREAT.
BUT, HOW INTEGRATION SERVICE INITIALIZES V_COUNT AS '0' , SO
THAT V_COUNT+1 RETURNS '1'?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist some properties of sessions.

730


Explain what are the different versions of informatica?

758


What is meant by LDAP users?

776


In informatics server which files are created during the session rums?

731


What is the fact table?

682






define galaxy repository in informatica

1825


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1732


in reporting we add some new objects,how we get the count of the newly added objects to the report

1860


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

715


What is different between the data warehouse and data mart?

717


How to load the data from a flat file into the target where the source flat file name changes daily?

662


what is song in infrmatica...?

1812


What is dimensional table? Explain the different dimensions.

768


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1315


What is sorter transformation?

682