sameer


{ City } banglore
< Country > india
* Profession * informatica developer
User No # 122662
Total Questions Posted # 0
Total Answers Posted # 6

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0
Questions / { sameer }
Questions Answers Category Views Company eMail




Answers / { sameer }

Question { IBM, 12251 }

Give Command that will move a single file
called "unix.txt"


Answer

MVP -v fil1 fil2

Is This Answer Correct ?    0 Yes 0 No

Question { 17442 }

Without source how to insert record to target?


Answer

Using mapplet designer we can create mapping think how then I will explain guys it's possible

Is This Answer Correct ?    0 Yes 0 No


Question { 11253 }

We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?


Answer

So in this situation we used the source qualifier transformations to convert the external datatype to informatica native datatype and by default source qualifier transformations is created if our source is a flat or relational tables and also one property is tracing level

Is This Answer Correct ?    1 Yes 0 No

Question { Cap Gemini, 8265 }

i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))


Answer

Based on the constraint based load we can load the data IT means emp table in target t1 and dept in target t2.

Is This Answer Correct ?    0 Yes 0 No

Question { 4452 }

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer


Answer

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

Is This Answer Correct ?    0 Yes 0 No

Question { Informatica, 1149 }

Which transformation can be created only as reusable transformation but not as non-reusable transformation?


Answer

Source Qualifier transformation

Is This Answer Correct ?    0 Yes 0 No