Answer Posted / rakesh

Thanks Vijaya.
In Expression we can use the date function to find the week number of the year. But here we have 1-nov-2011 as the column name, but not the column value. i.e; we have dates as column names, not as col values..
So please clarify..

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1109

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1052

---

Briefly describe lookup transformation?

982

---

What is update strategy transform?

1021

---

Why union transformation is an active transformation?

997

---

Do you find any difficulty while working with flat files as source and target?

1054

---

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

1036

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2802

---

What is lookup change?

989

---

How do you migrate data from one environment to another?

1044

---

What is the meaning of up gradation of repository?

1899

---

explain one complex mapping with logic? sales project?

6596

---

How can you define user defied event?

980

---

What are the differences between source qualifier and joiner transformation?

996

---

How can we use batches?

968

---