Answer Posted / murali

the surrogate key is the primary key used to avoid the
problem of critical column. let me clarify u with example...

table A:
Cust_no(PK) Cust_name Loc
100 X Mumbai

this is what ur OLAP DHW is having abt Customer X

But, he has changed his address from X to Y. U have to
update this in ur OLAP DWH. then, i u try to insert this
into ur Table A,
Error: Prinary key Constraint violated (Coz,PK is same for
the both the records)... then, LOC is the Critical Column.
to avoid this, we need to generate a primary key either by
user defined or system generated.

What are the tuning techniques you applied during your last project

2013

---

tell me the rules and responsblites in our project(my project is development)

1918

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1019

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2046

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2116

---

Is it possible to create multiple domains on a single Informatica server?

1220

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

993

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1989

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5643

---

What is an expression transformation?

999

---

Explain dynamic target flat file name generation in informatica

1035

---

What is an Integration service in Informatica?

1116

---

Design a mapping to load a target table with the following values from the above source?

1327

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1979

---

what is the complex transformation you used in informatica

2579

---