Answer Posted / bidhar

CDC is used when you want to pull the records which have
changed or newly added in the OLTP system.

Normally the OLTP tables have 2 columns
last_updated_timestamp and Added_timstamp.

Whenever a new record is added for the first time in these
tables then both the columns have the same timestamp ie
System timestamp.

Then when that particular record is changed only the column
last_updated_timestamp will change and the other column
Added_timstamp will remain same forever.

Now you need to pull this record when it was added as well
as when it was modified to keep your warehouse in sync with
OLTP system.

So based on last_updated_timestamp column (not
Added_timstamp)you need to pull the records.

This can be achieved by overriding the SQ query in the
where clause.

Example :- if product table in OLTP has 2000 records on
11th may and on 12th may 10 new records have come up and 5
records have been changed.Then in the next load 15 records
should be pulled to your warehouse.

Select Prd_nam,Typ,grp,category from product where
last_updated_timestamp>&&date_parameter

This is your SQ override query.
&&date_parameter is a mapping parameter which can be picked
up from a file.(you need to have the previous load max date
in that file which will be used as mapping parameter).

Hope this clears your doubt.

What are the steps involved in the migration from older version to newer version of Informatica Server?

1807

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1845

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1766

---

How to create the source and target database connections in server manager?

800

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1677

---

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9415

---

How to extract sap data using informatica?

770

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5322

---

Which transformation is needed while using the Cobol sources as source definitions?

917

---

What does update strategy mean, and what are the different option of it?

811

---

Explain pmcmd command usage in informatica

884

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

943

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1677

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

883

---

What is an aggregator transformation?

798

---