Answer Posted / gagan

Suppose first table as test created below create table test
(
city varchar2(50),
gender varchar2(50),
nmbr varchar2(50)
)

and keep all data in it as mentioned and then try to run
this query...


select a.city, a.nmbr as male, b.nmbr as female
from test a, test b
where a.gender = 'male' and b.gender = 'female' and b.city
= a.city

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.

2325

---

How can we create index after completion of load process?

1165

---

Parameter and variable differences

2110

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1114

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4150

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

2010

---

What are the transformations that are not supported in mapplet?

1084

---

Explain the etl program with few examples.

1115

---

Which files are created during the session rums by informatics server?

1233

---

What is lookup change?

1109

---

Explain the difference between a data warehouse and a data mart?

1111

---

Differentiate between sessions and batches?

1069

---

can u any challenge your project?

2083

---

How to use procedural logic inside infromatica?

1321

---

What is a router transformation?

1212

---