Interested to Buy Any Domain ? << Click Here >> for more details...
i have a session which creates a file every time when i runs
the session, but it replaces the first file with second file,i
want to append the second file follwed by first file when i
runs the session,how to achieve this?
- 1 Answers
- 5358 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer / priyank
select the option "append if exists" in the session
properties.
| Is This Answer Correct ? | 3 Yes | 0 No |
How to generate a single mapping for both the historical and incremental load.
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
how can u tune u r informatica mapppings
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
What is best approach to load 100 different source files (Different structure) to differet target tables ?
In development project what is the process to follow for an etl developer from day1
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
Explain about Informatica server process that how it works relates to mapping variables?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
Teradata 
