Question { Ericsson, 21042 }

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

Question { Reliance, 19784 }

what is Telecom regulatory body of India?

Answer

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

Question { Reliance, 25556 }

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

Question { Wipro, 13120 }

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

Question { Patni, 10787 }

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

Question { Cap Gemini, 8655 }

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

Question { IBM, 8367 }

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.