i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
- 7 Answers
- 23332 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raman m
If the 2 flat files have the same structure,then we can go
for filelist concept in informatica.
only one source qualifier is needed and the source should
be either of the flat files.
| Is This Answer Correct ? | 32 Yes | 0 No |
Answer / gourab
if you have the same file structure.you can configure
indirect loading in the file properties tab of the
session.You will need only one source qualifier
transformation.
Please correct me if i am wrong..
Regards
Gourab
| Is This Answer Correct ? | 29 Yes | 0 No |
Answer / dazzler
bsgr,
what's your problem dude. Why are u asking ppl to get in touch with u. Every now and then I'm finding your request among answers.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / srikanth
Source Qualifier transformation applies to only for
databases and not for flat files (upto versoin 7.x) but i
have no idea on later versions.
It just acts like a label and we cant configuare or use any
of the properties in source qualifier if the source is flat
file.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / naveen
If u have same structure then u can use union transformation
| Is This Answer Correct ? | 2 Yes | 8 No |
Answer / bsgsr
hi raman gud ans,
anyways i am srinvas here. my mail id is
bsrinivas1213@gmail.com wanna be in touch with you. well
its ur wish now
| Is This Answer Correct ? | 1 Yes | 30 No |
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
what is incremental data aggregation?
how to work with mapplet designer in informatica?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Define Update Override?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
What is informatica?
From where we can start or use pmcmd?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
How you know when to use a static cache and dynamic cache in lookup transformation?
Teradata 
