Interested to Buy Any Domain ? << Click Here >> for more details...
How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
- 10 Answers
- 25497 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / aakansha
It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.
| Is This Answer Correct ? | 15 Yes | 11 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Why do we need informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What do mean by local and global repository?
Explain sessions?
What is a stored procedure transformation?
What are the differences between joiner transformation and source qualifier transformation?
How does a sorter cache works?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Does an informatica transformation support only aggregate expressions?
Enlist the differences between database and data warehouse.
Where is metadata stored?
What is target designer and target load order?
