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.

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

What is workflow manager?

1100

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2073

---

Define pmcmd command?

1105

---

design of staging area?

2075

---

How can we use mapping variables in informatica?

1125

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2072

---

Explain incremental aggregation in informatica

1185

---

What is dimensional table? Explain the different dimensions.

1256

---

State the differences between sql override and lookup override?

1287

---

Enlist the differences between database and data warehouse.

1166

---

Explain what are the different types of transformation available in informatica.

1248

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1115

---

When do you use sql override in a lookup transformation?

1142

---

Can we create a Integration service without a Repository service and vice versa?

1260

---