I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

741

Explain InputFormat?

85

CAN ANY OF U TELL ME WHAT QUESTION ACTUALLY ASK IN OPERATION ROUND IN BA CONUTNNIUM SOLUTION

637

How did you customize IC for service project?

1647

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

446

How will u connect the multiple business servies?

700

How your potential can be better utilised by the Company?

1929

When we pass the parameters in CRM_order_read function module there are number of GUID are there, how particular GUID only fetch, for example 100 GUIDs are there in database when we pass data in function module how to fecth particular guid?

4590

What is the principle of Particle size analysis and zeta potential

1274

How to connect the remote desktop using QTP 9.2 explain the method or procedure?

2071

in plate load test what is the thickness of plate 20mm 5mm 50mm none

799

write a c program thal will find all sequences of length N that produce the sum is Zero, print all possible solutions?

1604

How to Reply to a Wild Address?

587

Hi Friends , i need one urgent help , i am preparing for M.tech entrance examination , i need some obejective questions related to instrumentation field. where can i get those ? can anyone help me pls ?

735

How would you do an Estimation?

514