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

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1851

---

How many number of sessions can one group in batches?

1156

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1040

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1168

---

What is the advantage of informatica?

1065

---

What are the reusable transformations?

1155

---

How is union transformation utilized?

1004

---

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

1079

---

What are the different versions of informatica?

1259

---

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

2035

---

Explain the different kinds of facts.

976

---

EXL informatica Questions

1383

---

What is primary and backup node?

1123

---

What is resilience time?

1128

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1917

---