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

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1674


What is mapplet in informatica?

670


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1673


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1879


While migrating the data from one environment to another environment how would you manage the connections?

723






Please let me know how to make Data masking in informatica..

1343


Differentiate between reusable transformation and mapplet.

701


can we override a native sql query within informatica? Where do we do it?

736


what is mean by complex business rule ?

1800


Explain the different lookup methods used in informatica?

686


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1618


Performance tuning( what you did in performance tuning)

1594


how tokens will generate?

1840


How do you load only null records into target? Explain through mapping flow.

1629


What are the different types of olap? Give an example?

646