Answer Posted / jvdwhinfo

Hi All,

Sources in Informatica can differ from Client to Client and
project to project.
But mostly client will send sample data through flat files.
And the metadata of the sample data is imported from Source
analyzer by clicking on the option import from file.

I hope i gave the relevant answer.
If am wrong please let me know.

Thanks.
James.

What are the components of Informatica? And what is the purpose of each?

981

---

list out all the transformations which use cache?

1111

---

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

---

Define Pmrep command?

995

---

Differentiate between sessions and batches?

962

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1994

---

What is meant by a domain?

1077

---

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 ?

1604

---

what is the size of u r source(like file or table)?

2199

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2052

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1194

---

Explain the different lookup methods used in informatica?

972

---

What is domain in terms of informatica?

952

---

Explian the Process of deployment groups in informatica

989

---

Mention few advantages of router transformation over filter transformation.

982

---