If I am having 6 flat files in data. How can you load the
data at a time
Answers were Sorted based on User's Feedback
Answer / sankar
for that 6 flat files make a one list file,then enter the
that 6 flat file paths in list file.
then session level select the type: inderect path:list file
patha filename:list
| Is This Answer Correct ? | 21 Yes | 0 No |
Name at least 5 different types of transformations used in mapping design and state the use of each.?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
why union is active transformation?
What is union transformation?
What are 2 modes of data movement in Informatica Server?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
What is rank transform?
how to we create datamart?
What is lookup change?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.