Answer Posted / santosh

HI ARUNAKUMARI,

IAM RAJU,WHAT IS MAPPPING DESIGN OF THIS SCENARIO AND WHERE WE DESIGN LIKE IN TRANSFORMER STAGE OR ANY AND WHAT IS(variableports)& WHICH STAGES ARE SQ AND EXP AND SORTER.
IAM A NEW IN DATASTAGE,PLS EXPLAIN ABOUT THIS CLEARLY

THANKS ADVANCE.
(here column names are not mentioned .so,i have taken them
as column1 and column2)

take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.

(variableports)curr_col1_val:column1

(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)

(variableports)pre_col1_val:column1

What is informatica?

1076

---

Explain what transformation and how many are there in informatica?

890

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1913

---

Which are the different editions of informatica powercenter that are available?

971

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1032

---

Is it possible to use a client with different version than that of its Informatica server?

1074

---

Can informatica load heterogeneous targets from heterogeneous sources?

1117

---

How you prepared reports for OLAP?

1545

---

What do you mean by enterprise data warehousing?

1002

---

What is decode in static cache?

1077

---

What is domain in terms of informatica?

952

---

write a query to retrieve the latest records from the table sorted by version(scd)

1003

---

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.

1941

---

What are the different types of olap? Give an example?

973

---

Explain sessions. Explain how batches are used to combine executions?

952

---