ahalya


{ City } bangalore
< Country > india
* Profession * developer
User No # 74948
Total Questions Posted # 10
Total Answers Posted # 7

Total Answers Posted for My Questions # 36
Total Views for My Questions # 91716

Users Marked my Answers as Correct # 24
Users Marked my Answers as Wrong # 44
Questions / { ahalya }
Questions Answers Category Views Company eMail

what is target load plan

Cap Gemini,

2 Informatica 5482

what is constraint based load order

Cap Gemini,

2 Informatica 6191

what is fact and what types of fact tables is there

Cap Gemini,

4 Informatica 9564

what is the main advantage of unconnected lookup

Cap Gemini,

2 Informatica 13287

what is junk dimension

Cap Gemini,

4 Informatica 5869

what is degenerated dimension

Cap Gemini,

6 Informatica 7803

what is the purpose of surrogate key and diff between primary key&surrogate key

Cap Gemini,

1 Informatica 5657

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

Cap Gemini,

9 Informatica 18807

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))

Cap Gemini,

5 Informatica 8234

what is normalization? explain 1st NF, 2nd NF, 3rd NF

SunGard,

1 Informatica 10822




Answers / { ahalya }

Question { Ericsson, 20751 }

1.What is the difference between Diplexer and Duplexer and
what position?
2. What is the different between CDU C and CDU A
3. How do you link a T1 from the 1st BTS to 2nd BTS
4. What is the value for TEI 1st T1?
5. What is the SSI?


Answer

value for T1
1.544

Is This Answer Correct ?    7 Yes 2 No

Question { Reliance, 18860 }

what is Telecom regulatory body of India?


Answer

ITU
international telecommunication union.
responsible for co-ordinating global telecommunication
activities

Is This Answer Correct ?    6 Yes 20 No


Question { Reliance, 24282 }

Which is the digital modulation used today in telecomn?
(whatever his question meant the answer was CDMA)
2) Why is walse code used? then, noncoherent detection,
coherent detection, Pn code(y it is used?) etc


Answer

tdma

Is This Answer Correct ?    4 Yes 17 No

Question { Wipro, 12426 }

Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.


Answer

SQ---> SEQ GEN---> EXP--> ROUTER---> TRG1, TRG2, TRG3, TRG4

in seq generator properties
start value-1
increment value-1
end value-4
current value-1
cycle-true
reset-true

in router conditions
4 conditions

group 1= iif ((nextval=1)1,0)
group 2=iif (( nextval=2)1,0)
group 3=iif((nextval=3)1,0)
group 4=iif((nextval=4)1,0)

connect
group1-->target1
group2-->target2
group3-->target3
group4-->target4

Is This Answer Correct ?    1 Yes 2 No

Question { Patni, 10252 }

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records


Answer

"Restart the session" . if the integration service has not issued at least one commit.
(or)
perform "Session Recovery" if the integration service has issued atleast one commit.
the I.S reads row id of last row commited from OPB_SRVR from repository table.
the I.S reads all the data from source , start processing from next row id..
we can perform session recovery when only target load type is normal. it can not support in bulk loading..

Is This Answer Correct ?    4 Yes 2 No

Question { Cap Gemini, 8234 }

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

interviewer asked the this question.. i too felt that its not possible to load into target without helping primary key foreign key relation ship.. but i am looking forward for more answers.. plz if any body can...

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 7877 }

my source is a comma delimited flatfile as
eno, ename, sal
111,sri,ram,kumar,1000
and my target should be
eno ename sal
111 sri ram kumar 1000
i.e; we need to eliminate the commas in between the data of a comma delimited file.


Answer

Go to the session properties.In that go to connections in that select the source name there you will find "Set file Properties" button. There you can set the delimeter.

Is This Answer Correct ?    2 Yes 1 No