Answer / upender

Bulk mode option used to load huge data.
normal mode option used to load small amount of data like
less than 1000 to 10000 records. It will fail, if you use
bulk mode option, loaded just 1 or 2 records.

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

When the informatica server marks that a batch is failed?

1 Answers  

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

what is hash table in informatica?

1 Answers   Zensar,

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

What are active and passive transformations?

0 Answers   Informatica,

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

---

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

0 Answers   TCS,

---