Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
- 4 Answers
- 18206 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jvdwhinfo
Hi Guys,
First of all create a new flat file and paste the location
of all the flat files in that newly created flat file.
Now import the source definition using "Import from file"
and define the mapping.
And assign the session properties as indirect file type of
loading and give the location of the newly created file.
This should do and please let me know if you want me to
discuss further.
Thanks,
James
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which files are created during the session rums by informatics server?
Explain what is informatica metadata and where is it stored?
list out all the transformations which use cache?
What is joiner transformation in informatica?
What is powercenter on grid?
What is decode in static cache?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Define pmcmd command?
What is workflow manager?
Slowly changing dimensions, types and where will you use them
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How union transformation is used?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is InformaticaPowerCenter?
What are Dimensional table?
