How to create a mapping ?
id date
101 2/4/2008
101 4/4/2008
102 6/4/2008
102 4/4/2008
103 4/4/2008
104 8/4/2008
O/P - shud have only one id with the min(date)
How to create a mapping for this
A Main workflow "wkf_Main" has multiple sessions (S1,
S2...., can I make changes and promte one session (S5) at
any time or have to promote whole Workflow "wkf_Main" every
time?
Hi All, i have question regarding Change Data Capture in
Informatica. As i know we can do this using Incremental
Aggregation(i never worked on Informatica but i read) and i
think we can do the same with SQL Over write and with
variables. Can someone tell me how do we do this using
other two techniques.. using SQL Over write and variables.
Thanks for the help and greatly appreciated.
Can anyone know that what is the Source File limitation in
Informatica?
To be more precise ..
how many flat file we can use as a source in a mapping if..
1) The Structure of flat files are same
&
2) If the Structure of flat files are different.
Please explain the procedure also if it dosn't bother one much!!
Hi all, i am new to this site and new to Informatica too. I
have few questions regarding that.
1) When we load flat files into target tables how do we
identify duplicates? and where do load the duplicate
records for further reference?
2) How do we do chage data capture? Is this Slowly changing
Dimension technique?
Thanks in Advance
When to use normalization transformation other than cobol
source?
62
How can one know that a table has indexes and is
partitioned? How data will be pulled from Partitions in
Oracle for Informatica?
49
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
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
15
insallation procedure for power center 8.1.1 especialy
domain_config
hw to use parameter files
191
Can you please mail me a copy of Informatica Certification
Exam dumps to sriveniv@hotmail.com
15
how tokens will generate?
127
what is mystery dimension?
147
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
Hi, Can someone send me the DWH and Informatica FAQ's at
priti.singh84@gmail.com Thanks in Advance, preeti
along with your userid / name. ThanQ
Site Map
