i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
Answer Posted / arnab
if both the files are same in structure you can concat into
one file using Unix or dos scripts and call the unix and
dos script before execution of the session in ur workflow
This would automate the process and you will not ahve to do
it manually
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What all join we can perform in LOOKUP transformation?
Why update strategy and union transformations are active? Explain with examples.
explain about unit testing? in real time?
Tell me about Propagate functions in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
can we override a native sql query within informatica? Where do we do it?
Explain load alternative records / rows into multiple targets - informatica
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
Describe the impact of several join conditions and join order in a joiner transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
r u done any partitions in ur project?
Explain your project of banking domian.
Differentiate between a repository server and a powerhouse?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Plz can any one say me how to get the informatica certification materials and dumps