Interested to Buy Any Domain ? << Click Here >> for more details...
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
- 5 Answers
- 9363 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / suman
if the coloumn name is different in sql override and in the
source qualifier it throws the error invalid identifier
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
How do you load first and last records into target table?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
In informatica workflow manager, how many repositories can be created?
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
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
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the sequence generator transformation in informatica?
How to extract sap data using informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a connected transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How can you validate all mappings in the repository simultaneously?
