Answer Posted / vidya

source -- sq -- exp1 -- exp2 -- t

exp1- create 4 var ports, and 1 output port as
v1=iif(col1=1, null, c1)
v2=iif(col2=1, null, c2)
v3=iif(col3=1, null, c3)
v4=iif(col4=1, null, c4)
op_port1=v1||v2||v3||v4
exp2- op_port1
create 3 out_put port
c1=substr(op_port1, 1,1)
c2=substr(op_port1, 2,1)
c3=substr(op_port1, 3,1)

To import the flat file definition into the designer where should the flat file be placed?

1044

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2378

---

What is the status code in stored procedure transformation?

1168

---

Performance tuning( what you did in performance tuning)

1960

---

What is mapplet in informatica?

1041

---

In informatica workflow manager, how many repositories can be created?

1336

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2041

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2302

---

What is repository manager?

975

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1648

---

What is meant by lookup transformation? Explain the types of lookup transformation?

935

---

How we can create indexes after completing the loan process?

1186

---

Explain why we use partitioning the session in informatica?

1072

---

Explain the types of lookup transformation?

1033

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2149

---