Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 25893 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Where is metadata stored?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the benefit of partitioning a session?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to update source definition?
What is a repository? And how to add it in an informatica client?
What is meant by a domain?
Make a note of the quantity vaults made in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the types of schemas we have in data warehouse and what are the difference between them?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is olap (on-line analytical processing?
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.
What are the issues you have faced in your project? How did you overcome those issues?
What is meant by incremental aggregation?
