if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Answer Posted / kumarapillaietl@gmail.com
We can write any order under SQL query like Oracle SQL part , but the main thing is we need to maintain that query order in our all mapping flow. Else it's error
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
Which are the different editions of informatica powercenter that are available?
What are session parameters ? How do you set them?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what are the deliverables?in your project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a filter transformation and why it is an active one?
What do you mean by enterprise data warehousing?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Mention few advantages of router transformation over filter transformation.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Which files are created during the session rums by informatics server?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the difference between stop and abort in informatica