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
- 25432 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kishore
We can use union all Transforamtion .if the struture is
same....
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the difference between router and filter?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How does the aggregator transformation handle null values?
What is a mapplet/worklet in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
how to create user defined function (udf) in informatica
How to load last n records of file into target table - informatica
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
generate date / time dimension in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the cumulative sum and moving sum?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is a node in Informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
