Help me bro..plaes...i didnt understand this requirement an exactly....
This code is located in the Account_Servicing_Fact_Load SSIS package.
The final container contains the code components needed to run both aggregation data.
You will have to incorporate the code into your process.
Tas 4:-Data Defect:-Missing data on some closed loans-Account servicing fact
.Run the following query:
Select * from
Account_Serving_Fact|_Test_AMC
where servicing_platform_cpde='Xerox'
and sub_portfolio='error'
and state is null
and prinbal is null order by csc_id, filedt
.Identify the accounts that show up and determine why these values are being set to Null via the
FCA_ACCOUNT_servicing_fact_test_amc_load stored procedure.
.You will need to debug through the code to find the accounts are failing out of the process.
When i ran the above query it is displaying the NULLS from all columns and If i put the same code within where clause with a Few columns as IS NOT NULL, It shows the data ,
Select columnames from
Account_Serving_Fact|_Test_AMC
where servicing_platform_cpde='Xerox'
and sub_portfolio='error'
and state is not null
and prinbal is not null group by columns.
But my manager want me to find out why all these field have null values.Am struggling with this what he is asking an exact.
If ran the query ---->Select * from
Account_Serving_Fact|_Test_AMC
where servicing_platform_cpde='Xerox'
and sub_portfolio='error'
and state is not null
and prinbal is not null null order by csc_id, filedt
It shows executing, finally it is failed after the long ran.
Please help me here bro, I thought he needed the data which is completely not come by NULLS.There are so many columns are there.
Even i tried with this query to filter out the NULLS data....
SELECT * FROM tablename WHERE col1+col2+col3+col4 IS NULL;----To return for only Null values
Union
SELECT * FROM tab1ename WHERE col1+col2+col3+col4 IS NOT NULL;--To return only the data an except NULL'S.
Note:-I hope you can help on this bro.
Thank You very much and your kind on helping to the global for every member.