How to jion 2 tables, without using any condition?
Answer Posted / rkumar.etl
use user defined join option.
| Is This Answer Correct ? | 3 Yes | 16 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
How can we remove the duplicates from flat file source?
How to extract sap data using informatica?
Name the different lookup cache(s)?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is Session and Batches?
What is the status code in stored procedure transformation?
Differentiate between Load Manager and DTM?
Explain the aggregator transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
State the limitations where we cannot use joiner in the mapping pipeline?
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?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain lookup transformation in informatica
What is the need of an ETL tool?