I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
5 8326My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
3 6388My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
2 5126Post New Span Systems Interview Questions
What does "Null Safety" mean in Kotlin?
What is lazy loading in javascript?
Explain the difference between a generative and discriminative model?
Is there a formula for goal seek in excel?
how u will evaluate the tool for test automation?
Differentiate activity-dependent and activity-independent costs? : co- cost center accounting
What is DML (Data Manipulation Language)?
Explain data step in SAS
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
List different query types in microsoft access database
how to identify conection leads of an unknown electric motor
Explain modulus operator.
Explain how spectral lines show discrete energy levels in an atom. : quantum physics
Rate analysis of Vitrified tile in cement mortor 1:3
How to use group in a calculated field?