i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
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 |
What are events in workflow manager?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
why sequence generator should not directly connected to joiner transformation ?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
without matching columns in two tables. how can you join
Please let me know how to make encryption and decryption with example?
Enlist the tasks for which source qualifier transformation is used.
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
how we can load rejected record's at run time?(not through bad files)
how to design mapping half of source table records into one target and remaining half into another target
What is the need of building a data warehouse?