What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
978What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
1173What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
1 1482Post New Informatica Questions
What does update strategy mean, and what are the different option of it?
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 parallel processing in informatica?
Where do we use mapping variables in informatica?
How to go to the older version for a mapping?
What is mapping debugger?
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?
What is the difference between writing a joiner query in ANSI style and THETA style?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is a repository? And how to add it in an informatica client?
update strategy transformation in informatica
What is a node in Informatica?
How does a sorter cache works?
How can you increase the performance in joiner transformation?
Can we get 1st record through Informatica(without sequence number).