I have a flat file, in which i have two fields, emp_id,
emp_name. The data is like this,
emp_id,emp_name
101,soha
101,ali
101,khan
102,siva
102,shanker
102,reddy.
how to merge the names so that my output is like this
Emp_id Emp_name
101 Soha ali kahn
102 siva shenkar reddy
please provide solution
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.
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
141
Plz can anybody send Informatica and Cognos FAQ Plz To thid
ID anil643@gmail.com (or) kumar643@gmail.com
137
Comment on significance of oracle 9i in informatica when
compared to oracle 8 or 8i?
177
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 ?
99
in reporting we add some new objects,how we get the count
of the newly added objects to the report
I have a flat file, in which i have two fields, emp_id,
emp_name. The data is like this,
emp_id,emp_name
101,soha
101,ali
101,khan
102,siva
102,shanker
102,reddy.
how to merge the names so that my output is like this
Emp_id Emp_name
101 Soha ali kahn
102 siva shenkar reddy
please provide solution
7
What is a configuration management?
123
How can one know that a table has indexes and is
partitioned? How data will be pulled from Partitions in
Oracle for Informatica?
48
When to use normalization transformation other than cobol
source?
59
hi all,
I have to do Informatica Certification? Can any body send
me Some Informatica Certification Dumps/FAQS ? Advance
Thanks...
174
Can you please mail me a copy of Informatica Certification
Exam dumps to sriveniv@hotmail.com
14
How is Data Models Used in Practice?
131
What is Cognos script editor?
247
insallation procedure for power center 8.1.1 especialy
domain_config
hw to use parameter files