without matching columns in two tables. how can you join
Answer Posted / manjunath
Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What does refresh system mean, and what are its distinctive choice?
can we override a native sql query within informatica? Where do we do it?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Plz can any one say me how to get the informatica certification materials and dumps
How do you use reject loader.
What is a difference between complete, stop and abort?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What can we do to improve the performance of informatica aggregator transformation?
What is Data Caches size?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is pmcmd command?