Answer Posted / rahul

no its not possible.

sql trans is used to connect hetro src but when you drag
flat file n connect to Sq t/r , all properties expect
tracing level evey thing will be disable.

SO WE CANT JOIN

What is repository manager?

989

---

Where are the source flat files kept before running the session?

1078

---

what is informatica metadata?

1037

---

What is aggregator transformation in informatica?

950

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

---

generate date / time dimension in informatica

1125

---

how tokens will generate?

2204

---

wat are deployement groups in informatica, how it will be used for developers

1719

---

What is domain and gateway node?

1165

---

What is a snowflake schema?

995

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1906

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2036

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

---

What are the types of presistent cache in look up tr.

2055

---