i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this
Answer Posted / shekhar
can u just explain in detail the concatenation part.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Enlist the tasks for which source qualifier transformation is used.
Explain joiner transformation in informatica
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Why update strategy and union transformations are active? Explain with examples.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is incremental aggregation?
Can we create two repositories on same database instance in oracle?
what is SDLC way of code development?
How can we handle two sessions in informatica?
What is event and what are the tasks related to it?
Global and Local shortcuts. Advantages.
What are the types of caches in lookup? Explain them.
What is Session and Batches?