How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
i have a source which relational.I am trying to populate to
target flat file with one column for daily date which is
sysdate.
I want to populate the sysdate coulmn with DD/MM/YYYY
format.
kindly provide a solution for this..my clear that my target
is flat file.
If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
Can anyone give some input on "Additional Concurrent
Pipelines for Lookup Cache Creation" ? I know that this
property is used to build caches in a mapping concurently.
But which values should I set into this ( i.e. 1 or 2 or 3
or something else ) for concurrent cache building ?
HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard.....
I want to run a informatica worklow after complition of
oracle procedure. That procedure is not running through
informatica and can be run at any time in database.
Informatica is in windows environment. Is it possible ? If
yes please explain.
Please let me know how to do estimation before staring
development in project. Here estimation in the sense how
many associates are required, etc to complete the project.
Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one
target. Whenever I retreive the data(any record) from
target, i need to find the details that the record belongs
to which source.
Thanks in advance..
Can anyone give some input on "Additional Concurrent
Pipelines for Lookup Cache Creation" ? I know that this
property is used to build caches in a mapping concurently.
But which values should I set into this ( i.e. 1 or 2 or 3
or something else ) for concurrent cache building ?
91
hi all, I have to do Informatica Certification? Can any
body send me Some Informatica Certification Dumps/FAQS ?
Advance Thanks... Send me----: raghukrams@yahoo.com
139
how tokens will generate?
124
Hi, Can someone send me the DWH and Informatica FAQ's at
priti.singh84@gmail.com Thanks in Advance, preeti