Without using any transformations how u can load the data into
target?
Answer Posted / gaurav rustogi
Simply connected souce with target.
If any condition is there we can put in the Source Qualifier
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How does a sorter cache works?
How many ways a relational source definition can be updated and what are they?
What is the Process to creating lookup transformation in informatica
Briefly define a session task?
Mention a few design and development best practices for informatica?
How to extract the informatica rejected data?
What is enterprise data warehousing?
What is difference between a gateway node and worker node?
what is the size of u r source(like file or table)?
What are the uses of etl tools?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is exclusive and normal mode for repository services?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the components of workflow manager?
have u done any performance tuning? how u ll do?