How to jion 2 tables, without using any condition?
Answer Posted / raj
Add dummy column in expression or Source Qul. for both
source and use that column in join condition.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to join three sources using joiner? Explain though mapping flow.
What is meant by lookup transformation? Explain the types of lookup transformation?
Can we create two repositories on same database instance in oracle?
What is meant by LDAP users?
What are the components of workflow manager?
what is the size of your data warehousing?
waht type of interface is used for testing the data in informatica
What is the Process to creating lookup transformation in informatica
Explain pmcmd command usage in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What will be the approach?
Enlist the various types of transformations.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Differences between connected and unconnected lookup?