i have ten flat files with same structure,if
i want to load it to single target,and mapping needs to
should show only one source.what will be the steps to taken
to achieve it?/
Answers were Sorted based on User's Feedback
Answer / anoymous
Create a file system with extension .txt in that copy all
the 10 flat file paths.
Now at session level
source type : indirect
File directory : File system path
source file name: Name of file system.txt
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / arnab
Concat all the files using a Unix shell script to create a
new file and use this as the source file
If you use windows create a dos batch script
Then call the Unix shell script before calling the session
in the workflow , so that the process is automated
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prasuna
Hi shiva,thanks for giving answer..can u elaborate the
answer??
Is This Answer Correct ? | 0 Yes | 0 No |
where is the reject loader .
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
What happens when a session fails and you click on recover?
what are challenges that you faced in testing? give solution to it?
what is worklet and what use of worklet and in which situation we can use it?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
What are the new features of informatica 7.1?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
What is factless fact schema?