Answer / abhinaw prakash

You can write the query using both the source and target tables.

You can use the NOT IN and MINUS keyword.

Also you can make a mapping using both the tables and
generate a report on the missing records.

Answer / snjsngh15

Select count(*) from tableA A
Where not exist( select 1 from tableA D
Where B.id=D.id)
Minus
Select * from tablesB B
Where not exist( select 1 from tableB c
Where B.id=C.id)
Or
Select * from Table A
Minus
Select * from Table B

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

0 Answers  

---

What are two types of processes that informatica runs the session?

2 Answers  

---

Explain the different dimensions.

0 Answers  

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

---

---

 Informatica Checkpoints

0 Answers   DELL,

---

What do think which one is the better joiner or look up?

0 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

What are some examples of informatica etl programs?

0 Answers  

---