Interested to Buy Any Domain ? << Click Here >> for more details...
There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??
- 9 Answers
- 14104 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / amarnath
create a file list which is nothing but simple .txt file
which contains the name of the each file u want to load and
in session properties make source file as "indirect" and
give the path of the file list that u have created and run
the wkf
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are data-driven sessions?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain the shared cache and re-cache?
What is Cognos script editor?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what is the hint? how to use it to reduce the query processing in program?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How would you copy the content of one repository to another repository?
if we have a delimiters at unwanted places in a flat file how can we over come those.
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.
Which development components of informatica have the highest usage?
Why do you use Mapping Parameter and mapping variable?
What is parallel processing in informatica?
