HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answer Posted / sri
BY USING SOURCE QUALIFIER
| Is This Answer Correct ? | 6 Yes | 63 No |
Post New Answer View All Answers
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
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?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Where do we use mapping variables in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
in reporting we add some new objects,how we get the count of the newly added objects to the report
difference between informatica 8.1.1 and 8.6
Explain Dataware house architecture .how data flow from intial to end?
What is domain and gateway node?
What is the need of an ETL tool?
How to elaborate tracing level?
How is union transformation utilized?
What is meant by lookup transformation?
Describe an informatica powercenter?
What is the benefit of partitioning a session?